package com.qijian.system.domain.vo;

import java.math.BigDecimal;
import java.util.Date;
import com.fasterxml.jackson.annotation.JsonFormat;

import com.qijian.common.utils.mybatis.WhereType;
import com.qijian.common.utils.mybatis.WhereTypeEnum;
import lombok.Data;
import java.util.Set;
import lombok.ToString;
import com.baomidou.mybatisplus.annotation.TableName;


/**
 * 安全培训对象 查询条件类
 *
 * @author qijian
 * @date 2022-07-19
 */

@Data
@ToString
@TableName("eval_safety_train")
public class EvalSafetyTrainQuery {

    @WhereType(filed = "id")
    private Long id;
    @WhereType(filed = "id", type = WhereTypeEnum.IN)
    private Set<Long> ids;
    @WhereType(filed = "name", type = WhereTypeEnum.LIKE)
    private String name;
    @WhereType(filed = "train_date")
    private String trainDate;
    @WhereType(filed = "qualified_rate")
    private BigDecimal qualifiedRate;
    @WhereType(func = "DATE_FORMAT(train_date,'%Y') = {1}")
    private Integer year;
    @WhereType(func = "date_format(train_date,'%Y-%m') = {1}")
    private Integer ym;



}
